Requirement already satisfied: squarify in /home/pela/.local/lib/python3.8/site-packages (0.4.3)
/home/pela/Documents/ayush/customer_segm_RFM
| InvoiceNo | StockCode | Description | Quantity | InvoiceDate | UnitPrice | CustomerID | Country | |
|---|---|---|---|---|---|---|---|---|
| 0 | 536365 | 85123A | WHITE HANGING HEART T-LIGHT HOLDER | 6 | 01-12-2010 08:26 | 2.55 | 17850.0 | United Kingdom |
| 1 | 536365 | 71053 | WHITE METAL LANTERN | 6 | 01-12-2010 08:26 | 3.39 | 17850.0 | United Kingdom |
| 2 | 536365 | 84406B | CREAM CUPID HEARTS COAT HANGER | 8 | 01-12-2010 08:26 | 2.75 | 17850.0 | United Kingdom |
| 3 | 536365 | 84029G | KNITTED UNION FLAG HOT WATER BOTTLE | 6 | 01-12-2010 08:26 | 3.39 | 17850.0 | United Kingdom |
| 4 | 536365 | 84029E | RED WOOLLY HOTTIE WHITE HEART. | 6 | 01-12-2010 08:26 | 3.39 | 17850.0 | United Kingdom |
| ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 994 | 536520 | 22092 | BLUE PAISLEY TISSUE BOX | 1 | 01-12-2010 12:43 | 1.25 | 14729.0 | United Kingdom |
| 995 | 536520 | 22469 | HEART OF WICKER SMALL | 1 | 01-12-2010 12:43 | 1.65 | 14729.0 | United Kingdom |
| 996 | 536520 | 22100 | SKULLS SQUARE TISSUE BOX | 1 | 01-12-2010 12:43 | 1.25 | 14729.0 | United Kingdom |
| 997 | 536520 | 22096 | PINK PAISLEY SQUARE TISSUE BOX | 1 | 01-12-2010 12:43 | 1.25 | 14729.0 | United Kingdom |
| 998 | 536520 | 22583 | PACK OF 6 HANDBAG GIFT BOXES | 1 | 01-12-2010 12:43 | 2.55 | 14729.0 | United Kingdom |
999 rows × 8 columns
Timestamp('2010-01-12 12:43:00')
InvoiceNo object StockCode object Description object Quantity int64 InvoiceDate datetime64[ns] UnitPrice float64 CustomerID float64 Country object dtype: object
2011-12-10 00:00:00
| InvoiceNo | StockCode | Description | Quantity | InvoiceDate | UnitPrice | CustomerID | Country | TotalSum | Frequency | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 536365 | 85123A | WHITE HANGING HEART T-LIGHT HOLDER | 6 | 2010-01-12 08:26:00 | 2.55 | 17850.0 | United Kingdom | 15.30 | 696 days 15:34:00 |
| 1 | 536365 | 71053 | WHITE METAL LANTERN | 6 | 2010-01-12 08:26:00 | 3.39 | 17850.0 | United Kingdom | 20.34 | 696 days 15:34:00 |
| 2 | 536365 | 84406B | CREAM CUPID HEARTS COAT HANGER | 8 | 2010-01-12 08:26:00 | 2.75 | 17850.0 | United Kingdom | 22.00 | 696 days 15:34:00 |
| 3 | 536365 | 84029G | KNITTED UNION FLAG HOT WATER BOTTLE | 6 | 2010-01-12 08:26:00 | 3.39 | 17850.0 | United Kingdom | 20.34 | 696 days 15:34:00 |
| 4 | 536365 | 84029E | RED WOOLLY HOTTIE WHITE HEART. | 6 | 2010-01-12 08:26:00 | 3.39 | 17850.0 | United Kingdom | 20.34 | 696 days 15:34:00 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 994 | 536520 | 22092 | BLUE PAISLEY TISSUE BOX | 1 | 2010-01-12 12:43:00 | 1.25 | 14729.0 | United Kingdom | 1.25 | 696 days 11:17:00 |
| 995 | 536520 | 22469 | HEART OF WICKER SMALL | 1 | 2010-01-12 12:43:00 | 1.65 | 14729.0 | United Kingdom | 1.65 | 696 days 11:17:00 |
| 996 | 536520 | 22100 | SKULLS SQUARE TISSUE BOX | 1 | 2010-01-12 12:43:00 | 1.25 | 14729.0 | United Kingdom | 1.25 | 696 days 11:17:00 |
| 997 | 536520 | 22096 | PINK PAISLEY SQUARE TISSUE BOX | 1 | 2010-01-12 12:43:00 | 1.25 | 14729.0 | United Kingdom | 1.25 | 696 days 11:17:00 |
| 998 | 536520 | 22583 | PACK OF 6 HANDBAG GIFT BOXES | 1 | 2010-01-12 12:43:00 | 2.55 | 14729.0 | United Kingdom | 2.55 | 696 days 11:17:00 |
999 rows × 10 columns
Reference Date: 2011-12-10 00:00:00
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| CustomerID | 48.0 | 15558.083333 | 1842.620669 | 12431.0 | 13755.5 | 15687.5 | 17442.75 | 18085.0 |
| recency | 48.0 | 696.000000 | 0.000000 | 696.0 | 696.0 | 696.0 | 696.00 | 696.0 |
| CustomerID | recency | |
|---|---|---|
| 0 | 12431.0 | 696.0 |
| 1 | 12583.0 | 696.0 |
| 2 | 12791.0 | 696.0 |
| 3 | 12838.0 | 696.0 |
| 4 | 13047.0 | 696.0 |
| 5 | 13255.0 | 696.0 |
| 6 | 13408.0 | 696.0 |
| 7 | 13448.0 | 696.0 |
| 8 | 13694.0 | 696.0 |
| 9 | 13705.0 | 696.0 |
| 10 | 13747.0 | 696.0 |
| 11 | 13748.0 | 696.0 |
| 12 | 13758.0 | 696.0 |
| 13 | 13767.0 | 696.0 |
| 14 | 14045.0 | 696.0 |
| 15 | 14307.0 | 696.0 |
| 16 | 14527.0 | 696.0 |
| 17 | 14688.0 | 696.0 |
| 18 | 14729.0 | 696.0 |
| 19 | 14849.0 | 696.0 |
| 20 | 15100.0 | 696.0 |
| 21 | 15291.0 | 696.0 |
| 22 | 15311.0 | 696.0 |
| 23 | 15513.0 | 696.0 |
| 24 | 15862.0 | 696.0 |
| 25 | 15983.0 | 696.0 |
| 26 | 16029.0 | 696.0 |
| 27 | 16098.0 | 696.0 |
| 28 | 16210.0 | 696.0 |
| 29 | 16218.0 | 696.0 |
| 30 | 16250.0 | 696.0 |
| 31 | 16552.0 | 696.0 |
| 32 | 16583.0 | 696.0 |
| 33 | 17181.0 | 696.0 |
| 34 | 17377.0 | 696.0 |
| 35 | 17420.0 | 696.0 |
| 36 | 17511.0 | 696.0 |
| 37 | 17548.0 | 696.0 |
| 38 | 17809.0 | 696.0 |
| 39 | 17850.0 | 696.0 |
| 40 | 17897.0 | 696.0 |
| 41 | 17908.0 | 696.0 |
| 42 | 17920.0 | 696.0 |
| 43 | 17924.0 | 696.0 |
| 44 | 17951.0 | 696.0 |
| 45 | 17968.0 | 696.0 |
| 46 | 18074.0 | 696.0 |
| 47 | 18085.0 | 696.0 |
| CustomerID | recency | frequency | TotalSum | |
|---|---|---|---|---|
| 0 | 12431.0 | 696.0 | 1 | 358.25 |
| 1 | 12583.0 | 696.0 | 1 | 855.86 |
| 2 | 12791.0 | 696.0 | 1 | 192.60 |
| 3 | 12838.0 | 696.0 | 1 | 390.79 |
| 4 | 13047.0 | 696.0 | 3 | 366.63 |
| 5 | 13255.0 | 696.0 | 1 | 225.70 |
| 6 | 13408.0 | 696.0 | 1 | 1024.68 |
| 7 | 13448.0 | 696.0 | 2 | 443.96 |
| 8 | 13694.0 | 696.0 | 1 | 842.12 |
| 9 | 13705.0 | 696.0 | 1 | 318.14 |
| 10 | 13747.0 | 696.0 | 1 | 79.60 |
| 11 | 13748.0 | 696.0 | 1 | 204.00 |
| 12 | 13758.0 | 696.0 | 1 | 362.45 |
| 13 | 13767.0 | 696.0 | 1 | 507.88 |
| 14 | 14045.0 | 696.0 | 1 | 326.40 |
| 15 | 14307.0 | 696.0 | 1 | 783.11 |
| 16 | 14527.0 | 696.0 | 1 | -27.50 |
| 17 | 14688.0 | 696.0 | 1 | 444.98 |
| 18 | 14729.0 | 696.0 | 1 | 265.87 |
| 19 | 14849.0 | 696.0 | 3 | 355.84 |
| 20 | 15100.0 | 696.0 | 1 | 350.40 |
| 21 | 15291.0 | 696.0 | 1 | 328.80 |
| 22 | 15311.0 | 696.0 | 2 | 445.33 |
| 23 | 15513.0 | 696.0 | 1 | 357.00 |
| 24 | 15862.0 | 696.0 | 1 | 354.23 |
| 25 | 15983.0 | 696.0 | 1 | 440.89 |
| 26 | 16029.0 | 696.0 | 2 | 3702.12 |
| 27 | 16098.0 | 696.0 | 1 | 430.60 |
| 28 | 16210.0 | 696.0 | 1 | 2474.74 |
| 29 | 16218.0 | 696.0 | 1 | 471.30 |
| 30 | 16250.0 | 696.0 | 1 | 226.14 |
| 31 | 16552.0 | 696.0 | 1 | 95.29 |
| 32 | 16583.0 | 696.0 | 1 | 233.45 |
| 33 | 17181.0 | 696.0 | 1 | 155.52 |
| 34 | 17377.0 | 696.0 | 1 | 223.90 |
| 35 | 17420.0 | 696.0 | 1 | 130.85 |
| 36 | 17511.0 | 696.0 | 1 | 1825.74 |
| 37 | 17548.0 | 696.0 | 1 | -141.48 |
| 38 | 17809.0 | 696.0 | 1 | 34.80 |
| 39 | 17850.0 | 696.0 | 10 | 1499.34 |
| 40 | 17897.0 | 696.0 | 2 | 140.39 |
| 41 | 17908.0 | 696.0 | 1 | 243.28 |
| 42 | 17920.0 | 696.0 | 1 | 514.41 |
| 43 | 17924.0 | 696.0 | 1 | 279.00 |
| 44 | 17951.0 | 696.0 | 1 | 295.50 |
| 45 | 17968.0 | 696.0 | 1 | 277.35 |
| 46 | 18074.0 | 696.0 | 1 | 489.60 |
| 47 | 18085.0 | 696.0 | 1 | 303.90 |
CustomerID 0 Recency 0 Frequency 0 Monetary 0 dtype: int64
| CustomerID | Recency | Frequency | Monetary | |
|---|---|---|---|---|
| 0 | 12431.0 | 696.0 | 1 | 358.25 |
| 1 | 12583.0 | 696.0 | 1 | 855.86 |
| 2 | 12791.0 | 696.0 | 1 | 192.60 |
| 3 | 12838.0 | 696.0 | 1 | 390.79 |
| 4 | 13047.0 | 696.0 | 3 | 366.63 |
| 5 | 13255.0 | 696.0 | 1 | 225.70 |
| 6 | 13408.0 | 696.0 | 1 | 1024.68 |
| 7 | 13448.0 | 696.0 | 2 | 443.96 |
| 8 | 13694.0 | 696.0 | 1 | 842.12 |
| 9 | 13705.0 | 696.0 | 1 | 318.14 |
| 10 | 13747.0 | 696.0 | 1 | 79.60 |
| 11 | 13748.0 | 696.0 | 1 | 204.00 |
| 12 | 13758.0 | 696.0 | 1 | 362.45 |
| 13 | 13767.0 | 696.0 | 1 | 507.88 |
| 14 | 14045.0 | 696.0 | 1 | 326.40 |
| 15 | 14307.0 | 696.0 | 1 | 783.11 |
| 16 | 14527.0 | 696.0 | 1 | -27.50 |
| 17 | 14688.0 | 696.0 | 1 | 444.98 |
| 18 | 14729.0 | 696.0 | 1 | 265.87 |
| 19 | 14849.0 | 696.0 | 3 | 355.84 |
| 20 | 15100.0 | 696.0 | 1 | 350.40 |
| 21 | 15291.0 | 696.0 | 1 | 328.80 |
| 22 | 15311.0 | 696.0 | 2 | 445.33 |
| 23 | 15513.0 | 696.0 | 1 | 357.00 |
| 24 | 15862.0 | 696.0 | 1 | 354.23 |
| 25 | 15983.0 | 696.0 | 1 | 440.89 |
| 26 | 16029.0 | 696.0 | 2 | 3702.12 |
| 27 | 16098.0 | 696.0 | 1 | 430.60 |
| 28 | 16210.0 | 696.0 | 1 | 2474.74 |
| 29 | 16218.0 | 696.0 | 1 | 471.30 |
| 30 | 16250.0 | 696.0 | 1 | 226.14 |
| 31 | 16552.0 | 696.0 | 1 | 95.29 |
| 32 | 16583.0 | 696.0 | 1 | 233.45 |
| 33 | 17181.0 | 696.0 | 1 | 155.52 |
| 34 | 17377.0 | 696.0 | 1 | 223.90 |
| 35 | 17420.0 | 696.0 | 1 | 130.85 |
| 36 | 17511.0 | 696.0 | 1 | 1825.74 |
| 37 | 17548.0 | 696.0 | 1 | -141.48 |
| 38 | 17809.0 | 696.0 | 1 | 34.80 |
| 39 | 17850.0 | 696.0 | 10 | 1499.34 |
| 40 | 17897.0 | 696.0 | 2 | 140.39 |
| 41 | 17908.0 | 696.0 | 1 | 243.28 |
| 42 | 17920.0 | 696.0 | 1 | 514.41 |
| 43 | 17924.0 | 696.0 | 1 | 279.00 |
| 44 | 17951.0 | 696.0 | 1 | 295.50 |
| 45 | 17968.0 | 696.0 | 1 | 277.35 |
| 46 | 18074.0 | 696.0 | 1 | 489.60 |
| 47 | 18085.0 | 696.0 | 1 | 303.90 |